package com.ncepu.clubmanagement.mapper;

import com.ncepu.clubmanagement.pojo.School;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface UniversityMapper {

    @Select("select * from school where sch_name like concat('%',#{schName},'%')")
    List<School> getSchByName(String schName);

    @Select("select * from school where sch_id = #{schId}")
    School getSchById(Integer schId);

    @Select("select * from school")
    List<School> getAllSch();
}
